1 10 11 12 2 3 4 5 6 7 8 9

Select *
From YourTable
Order by CAST( SUBSTRING(YourColumn, 6,LEN(YourColumn)) AS Int)