Reuire the order od data from table that it was inserted in sequence

[Monalee Bhandge (DBA)]

I have one table with col1 VARCHAR(50).
Data in that table is as
-----------------
col1
-----------------
Axbo 1
Axbo 2
Axbo 4
Axbo 3
Axbo 5
Axbo 7
Axbo 6
Axbo 8
Axbo 9
Axbo 10
Axbo 12
Axbo 11

Now I would like retriew data from this column by ascending order of number exist after Axbo word.

Can I make order clause on VARCHAR datatype after given substring set.
e.g ORDER BY col1.subString(After 4 letters)

I also try for ORDER BY NULL, but it doesn't work.


My Result should be
-----------------
col1
-----------------
Axbo 1
Axbo 2
Axbo 3
Axbo 4
Axbo 5
Axbo 6
Axbo 7
Axbo 8
Axbo 9
Axbo 10
Axbo 11
Axbo 12