MySQL 8.0

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

CREATE TABLE address(
	No INT(11),
	ip VARCHAR(25),
	router VARCHAR(50),
	idZone INT(11),
	vlan INT(11)
);
INSERT INTO address (No,ip,router,idZone,vlan) VALUES(9600, '10.95.65.100', '10.10.10.26', 2, 105)
,(9601, '10.95.65.101', '10.10.10.26', 2, 105)
,(9602, '10.95.65.102', '10.10.10.27', 2, 107)
,(16090, '10.32.5.90', '10.10.10.25', 1, 103)
,(16091, '10.32.5.91', '10.10.10.25', 1, 103)
,(16092, '10.32.5.92', '10.10.10.25', 1, 103)
,(16093, '10.32.5.93', '10.10.10.25', 1, 103)
,(16095, '10.32.5.95', '10.10.10.25', 1, 103)
,(20100, '10.20.10.200', '10.10.10.32', 3, 109);
SELECT
    MIN( no ) AS start_no,
    MAX( no ) AS end_no,
    router,
    idZone,
    vlan
FROM
    address
GROUP BY
    router,
    idZone,
    vlan 
ORDER BY vlan


start_no
end_no
router
idZone
vlan


16090
16095
10.10.10.25
1
103

9600
9601
10.10.10.26
2
105

9602
9602
10.10.10.27
2
107

20100
20100
10.10.10.32
3
109

start_no	end_no	router	idZone	vlan
16090	16095	10.10.10.25	1	103
9600	9601	10.10.10.26	2	105
9602	9602	10.10.10.27	2	107
20100	20100	10.10.10.32	3	109