want to create a unique id like this

[rvservicecenter]

I want to create a unique id that automatically gets filled when i start entering data in that row. I want the unique id to work like this - it begins with A0001 lasts till A9999 and then it starts with B0001 till B9999 and goes so on. Is this possible?

currently i am using this formula =

={"ID";ARRAYFORMULA(IF(C2:C="",,"A-" & TEXT(Sequence(10000,1,1,1),"0001")))}