Unique format for primary key that automaticy increases


I'd love some assistance with a custom SQL

I'm looking to create a SQL for my primary key that starts with four digits (0001) and increases by 1 every time a new row is created.

Thanks for your help in advance.


Would you be open to using something like the solution mentioned here? Otherwise, curious to know what kind of SQL you're using :thinking: