If you would like to treat text data as numeric, you have to convert it. For example:
SELECT *
FROM (
SELECT 'HO463919493' AS F1, NULL AS F2
UNION ALL
SELECT 'HO463919493', '02'
UNION ALL
SELECT 'HO463919493', '02'
UNION ALL
SELECT 'HO463919493', '03'
UNION ALL
SELECT 'HO463919493', '01'
UNION ALL
SELECT 'HO463919493', '03'
UNION ALL
SELECT 'HO463919493', '01'
) AS T
ORDER BY CONVERT(INT, SUBSTRING(F1, 3, LEN(F1))) ASC, CONVERT(INT, F2) ASC
Note: Above sample is for specific data, where first two letters are rejected during conversion.