generate sequence number using sql

Question

generate reference number using sql but only one number is in like these 0001  

 

if it is generated and the number will give to form or some thing after that 0001 +1 =0002 will be generated

 

like wise dont add number sequence ly in table  

 

 

I am Waiting