MySQL 5.7

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

create table table1(id int, description varchar(20));
insert into table1(id, description) values
(1, 'item1'), (2, 'item2'), (3, 'item8'), (4, 'item4'), (5, 'item5'),
(6, 'item6'), (7, 'item7'), (8, 'item8'), (9, 'item9'), (10, 'item10');
                                                
create table table2(id int, id_start int, id_end int);
insert into table2(id, id_start, id_end) values
(1, 1, 3), (2, 4, 5), (3, 6, 8), (4, 9, 10);
select t1.id, t1.description
from table1 t1 
inner join (
  select id, id_start, id_end, rand() rnd
  from table2
  group by id, id_start, id_end
) t2
on t1.id between t2.id_start and t2.id_end
order by t2.rnd, rand()


id
description


1
item1

2
item2

3
item8

6
item6

8
item8

7
item7

4
item4

5
item5

9
item9

10
item10


select t1.id, t1.description
from table1 t1 
inner join (
  select id, id_start, id_end, rand() rnd
  from table2
  group by id, id_start, id_end
) t2
on t1.id between t2.id_start and t2.id_end
order by t2.rnd, rand()


id
description


1
item1

3
item8

2
item2

9
item9

10
item10

4
item4

5
item5

7
item7

8
item8

6
item6

id	description
1	item1
2	item2
3	item8
6	item6
8	item8
7	item7
4	item4
5	item5
9	item9
10	item10