natsort (di php) in mysql

[jup&gian]

SELECT riferimento
FROM tabella

ORDER BY INT(SUBSTR(riferimento,3,4))