Seems your rule for extracting a number from a string is quite complicated.
If so, I propose to write a function "get_num" for getting this number from a string
and returning 999999999 when you can't do it - and then
Order By get_num(your_field), your_field