MySQL version of php natsort()

natsort.sql

SELECT *
FROM %table_name%
ORDER BY
(CASE WHEN ASCII(RIGHT(%column_name%, 1)) > 47 AND ASCII(RIGHT(%column_name%, 1)) < 58
  THEN LPAD(CONCAT(%column_name%, '-'), 5, '0')
  ELSE LPAD(%column_name%, 5, '0')
  END);

Change %table_name% to actual table name and %column_name% to actual column name in table.
Use expression in parentheses each time you need a sorting by that column in natural order (like php natsort()).