Can I use… NATURAL_SORT_KEY(<string>)

The function natural_sort_key allows sorting strings that contain numbers in a more natural way.

SELECT *
  FROM …
 ORDER BY NATURAL_SORT_KEY(text_col)

Related

Standard SQL uses collations to specify how strings are to be sorted. Known implementations that support naturally sorting collations:

• PostgreSQL 10+ with ICU collations (see the “numeric” example in the documentation).

Normative References

The natural_sort_key function is not defined by any international standard.

Vendor documentation:

• MariaDB: NATURAL_SORT_KEY