sql database how to arrainged code as illustrated bellow

Question

i have the table with code and i want to follow this criteria 0001 ,0002, but when it reaches to 10 to turn to 0010 when reaches to to turn this 0100