MySQL 8.0

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

CREATE TABLE table1 (
    barcode varchar(255)
);
INSERT INTO table1 VALUES 
('HYD123'), 
('HYD1234'), 
('HYD132453741 ');

Records: 3  Duplicates: 0  Warnings: 0

select *
from table1;

barcode

HYD123

HYD1234

HYD132453741

SELECT  oo.barcode, cast(SUBSTRING_INDEX(oo.barcode,'HYD',-1) AS UNSIGNED INTEGER)
FROM table1 oo
WHERE cast(SUBSTRING_INDEX(oo.barcode,'HYD',-1) AS UNSIGNED INTEGER) between 122 and 1250

barcode
cast(SUBSTRING_INDEX(oo.barcode,'HYD',-1) AS UNSIGNED INTEGER)

HYD123
123

HYD1234
1234