Order by on an alphanumerical column
MySQL has a built-in function for parsing texts in the form of SUBSTRING_INDEX().

This simplifies your query to:

SELECT * FROM the_table
ORDER BY CAST(SUBSTRING_INDEX(data,' ',-1) AS UNSIGNED);