SELECT column_name
FROM table_name
ORDER BY CAST(column_name AS UNSIGNED);

SELECT name, grade
FROM students
ORDER BY CAST(grade AS UNSIGNED);

| name   | grade |
|--------|-------|
| David  | 80    |
| Bob    | 85    |
| Alice  | 90    |
| Cindy  | 95    |

SELECT column_name
FROM table_name
ORDER BY CAST(SUBSTRING(column_name FROM '[0-9]+') AS UNSIGNED);

SELECT name, grade
FROM students
ORDER BY CAST(SUBSTRING(name FROM '[0-9]+') AS UNSIGNED);

| name   | grade |
|--------|-------|
| 1Alice | 90    |
| 2Bob   | 85    |
| 3Cindy | 95    |
| 4David | 80    |

DELIMITER CREATE FUNCTION GetNumeric(s VARCHAR(255))
RETURNS VARCHAR(255)
DETERMINISTIC
BEGIN
  DECLARE len INT;
  DECLARE pos INT;
  SET len = LENGTH(s);
  SET pos = 1;

  WHILE pos <= len DO
    IF SUBSTRING(s, pos, 1) REGEXP '[0-9]' THEN
      SET s = SUBSTRING(s, pos);
      SET len = LENGTH(s);
      SET pos = 1;
    ELSE
      SET pos = pos + 1;
    END IF;
  END WHILE;

  RETURN s;
END
DELIMITER ;

SELECT column_name
FROM table_name
ORDER BY CAST(GetNumeric(column_name) AS UNSIGNED);