This is possible with the effect creator. What you need to do first is create a scene for every frame. Every scene should have another light switched on (with a brightness/colour). Then open the effect creator. Switch on the options “I want to set brightness per frame” and “Toggle light states in frames”. Then add all of those scenes to this effect with a delay of one second between them.
See for more information: Turn lights on one by one and How to use the Effect Creator?
Let me know if you have any questions.