Sorting of Alphanumeric Column

select x, cast (substring(x,'[0-9]+') as int) as y from test order by y,x

Here x is field name and regular expression is used to filter