MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test
(
val varchar(5)
)
insert into test (val) values('A-1'),('A-10'),('A-9')
select max(cast(substr(val,3) as signed)) from test


max(cast(substr(val,3) as signed))


10