例如:苹果1,梨子2,桔子3
order by to_number(regexp_substr(字段名,'[0-9]*[0-9]',1))
参考:https://blog.csdn.net/weixin_34214500/article/details/92671075