To make it more flexibel you can use this
select x from t order by cast(substr(x, 1 ,5) as unsigned), x
Here is the complete fiddle
The substr is only nessesary if you have numbers in the String behind the numbers to sort for. You can change the 5 to 3 if the maximum number is 999 for exmple