How to achieve this effect?

It is a postprocess effect which happens masked by a growing radius sphere. You need to research 1st to a postprocess which can give you the look, than you set it to your postprocessvolume and when activated you just drive the value for a spheremask radius for a amount of time enough for the duration you want the effect to go.