Selamlar,
between operatorü ile yapabilirsiniz.

SELECT * FROM tablo WHERE id BETWEEN 80 AND 125;

https://www.techonthenet.com/mysql/between.php