prova così

select *,substring_index(title,'#',1) as nominale,
cast(substring_index(title,'#',-1) as unsigned) as numero
from tabella order by nominale,numero