Yes, you can. In case you want to sort by numbers, you need to extract numeric part, for example:
SELECT FieldName, LEFT(FieldName, 3) AS FirstPart, CONVERT(INT, RIGHT(FieldName, LEN(FieldName)-3)) AS SecondPart
FROM TableName
ORDER BY CONVERT(INT, RIGHT(FieldName, LEN(FieldName)-3)) ASC