DROP FUNCTION IF EXISTS Normalize;

DELIMITER @@;

CREATE FUNCTION Normalize (val VARCHAR(255), delim CHAR(1), len INT)
RETURNS VARCHAR(255) DETERMINISTIC
BEGIN
	DECLARE Result VARCHAR(255) DEFAULT '';
	DECLARE Temp VARCHAR(255) DEFAULT '';
    WHILE val != '' DO
		SET Temp := SUBSTRING_INDEX(val, delim, 1);
		SET val := SUBSTRING(val FROM 2 + LENGTH(Temp));
		SET Result := CONCAT(Result, delim, REPEAT('0', len - LENGTH(Temp)), Temp);
	END WHILE;
	RETURN TRIM(LEADING delim FROM Result);
END;
@@;

DELIMITER ;

UPDATE data_table
SET id = Normalize(id, '.', 2);

SELECT *
FROM table
ORDER BY Normalize(id, '.', 2);

SELECT * from t_table order by CONVERT(REPLACE(some_field, '.', '0') SIGNED INTEGER);

SELECT x  from test.table1  order BY CONVERT( RPAD(REPLACE(x, '.', ''),10,'0'),UNSIGNED integer) ;