MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test
(
    v varchar(100) NOT NULL
    , n int NOT NULL
);
INSERT INTO test (v, n)
VALUES (0, '0')
    , (1, '1')
    , (2, '2')
    , (100, '100')
    , (99, '99');
SELECT *
FROM test
ORDER BY CONVERT(v,decimal(18,4));


v
n


0
0

1
1

2
2

99
99

100
100