Auto Increment ID in Existing Data in database

1st Step: Create SerialId in Table int

is Identity Yes

Identity Seed:7 digit(0000000)

then save.

2nd Step:

Create another coloum SerialNo varchar

update it with previous SerialId  

run this query 

update StyleSize set serialNo = right(cast(SerialId as nvarchar(10)),6)