select col1,col2,identity(int,1,1) col3 into #tb from tb
select * from #tb

------解决方案--------------------
SQL code
--增加col3列
alter table tb add col3 int
--修改col3列
update tb set col3=cast (right(col1,1) as int) 
--排序查询
select * from tb order by col3