No, this effect cannot be achieved with lights. I think it’s done using a Particle System.
I think it’s a combination of half a sphere and a material effect for this Particle System.
You could watch this sort of Tutorial playlist for Particle system effect by Luos: