Como ordenar los datos de una select en base al valor numerico de una columna de text

[Myakire]

Dice la documentación de Cast :

...
CAST(expr AS type)
CONVERT(expr,type)
CONVERT(expr USING transcoding_name)
The CAST() and CONVERT() functions can be used to take a value of one type and produce a value of another type. The type can be one of the following values:
BINARY
CHAR
DATE
DATETIME
SIGNED [INTEGER]
TIME
UNSIGNED [INTEGER]
...

Entonces, podría quedar:

Código:

SELECT     *
FROM         Tipos
ORDER BY CAST(Clave_Cadena AS SIGNED )

Saludos