Seems,
Slno
is varchar data type. To be able to sort data in correct order, you have to use proper data type (int).
But now, you can try something like this:
SELECT *
FROM TableName
ORDER CONVERT(INT, Slno) ASC
For further information, please see:
CAST and CONVERT (Transact-SQL)[
^]