Out of interest, I just tried restarting my PC (690 Hero) in different ways and the exact LED sequence seems to vary (if I have remembered correctly), as follows:
Restart (PSU left on ) = normal sequence = red, yellow, white, green
Boot after shutdown (PSU left on) = red, red, red, yellow, white green
Boot after shutdown (PSU off) = red, yellow, red, yellow, white, green (which seems to match what you have described)
There are also codes that flash up briefly between the LED sequences given above.
As long as the LEDs are all off once it gets past the POST process, then I don't think there is anything to worry about. I had not noticed any of this before, so I'm assuming it's normal, as I have no problems that I'm aware of.
Z690 Hero, BIOS 2305, ME Firmware 126.96.36.1996, 7000X Case, RM1000x PSU, i9 12900K, ASUS TUF OC 3090TI, 2 x 16GB Corsair RAM @ 5200MHz, Windows 11 Pro 22H2, Corsair H150i Elite AIO, 4x Corsair RGB fans, 3x M.2 NVME drives, 2x SATA SSDs, 2x SATA HDs.