By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table models as
select '50 EC-X' as name union all
select '250 ETC Enduro, silver' as name union all
select '350 ETC 2014' as name union all
select '450 ETC 2014' as name union all
select '690 ETC 2014' as name union all
select '1200 Superenduro' as name union all
select 'RS 1200 Superenduro'
select *
from models
order by regexp_substr(name, '[0-9]+') + 0
| name |
|---|
| 50 EC-X |
| 250 ETC Enduro, silver |
| 350 ETC 2014 |
| 450 ETC 2014 |
| 690 ETC 2014 |
| 1200 Superenduro |
| RS 1200 Superenduro |