MySQL 8.0

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

CREATE TABLE table1
    (`ID` varchar(40))
;
    
INSERT INTO table1
    (`ID`)
VALUES
    ('007eefab-5f77-4584-b41c-db09785c6e52'),
    ('''0138ba80-47ad-414a-bcea-65f0ca165a2a'),
    ('022f1261-32e7-4870-bc29-2fc770260bc2'),
    ('02d756dc-c6ca-446a-a17a-ab52b1341595'),
    ('03a8242b-0d6f-4680-9890-b90e53d46f89'),
    ('03c56406-91f0-4c25-9d07-a4c91df565e5'),
    ('0521cabb-94de-4186-ae8e-07e11b8de01f'),
    ('06e24fc0-5dc7-4b0b-9797-93964d22f5de'),
    ('0822c7fb-ebe9-43cd-8f0e-df7fda50f711'),
    ('09353ab2-6e17-4948-868c-a617977f3902'),
    ('0a11a144-6e88-106d-9ba2-105a00000028'),
    ('0a11a144-6e88-106d-9ba2-11060000002a'),
    ('0a11a144-6e88-106d-9ba2-11970000002c'),
    ('0a11a144-6e88-106d-9ba2-12120000002f'),
    ('0a11a144-6e88-106d-9ba2-4fb40000005f'),
    ('0a11a144-6e88-106d-9ba2-4fbd00000060'),
    ('0a11a144-6e88-106d-9ba2-506100000067'),
    ('0a11a144-6e88-106d-9ba2-56cf0000006d'),
    ('0a11a144-6e88-106d-9ba2-57b200000073'),
    ('0a11a144-6e88-106d-9ba2-580100000077'),
    ('0a11a144-6e88-106d-9ba2-580d00000078'),
    ('0a11a144-6e88-106d-9ba2-581100000079'),
    ('0a11a144-6e88-106d-9ba2-5b440000008c'),
    ('0a11a144-6e8d-190f-9ba3-64fe00000001'),
    ('0a11a144-6e8d-190f-9ba3-683100000010'),
    ('0a11a144-6e8d-190f-9ba3-68b20000001a'),
    ('0a11a144-6e8d-190f-9ba3-68e20000001e'),
    ('0a11a144-6e8d-190f-9ba3-691700000020'),
    ('0a11a144-6e8d-190f-9ba4-b1b5000001ba'),
    ('0a11a144-6e8d-190f-9ba4-b201000001c4'),
    ('0a11a144-6e8d-190f-9ba4-b290000001cc'),
    ('0a348078-58fd-12fd-963f-6e3700000507'),
    ('0a348078-58fd-12fd-963f-86fa000008a2'),
    ('0a348078-58fd-12fd-9640-24f000000c9d'),
    ('0a348078-58fd-12fd-9641-73a7000475a3'),
    ('0a348078-58fd-12fd-9641-ba92000649b0'),
    ('0a348078-58fd-12fd-9641-dc9800070215'),
    ('0a348078-58fd-12fd-9641-e05900070345'),
    ('0a348078-58fd-12fd-9641-e0bf00070351'),
    ('0a348078-58fd-12fd-9642-bcfe00099496'),
    ('0a348078-58fd-12fd-9644-06b9000c1f04'),
    ('0a348078-5911-1bfe-9645-4b370000032a'),
    ('0a348078-5916-1f0d-9646-94da00001308'),
    ('0a348078-5916-1f0d-9649-2cfa00053e55')
;
SELECT 
    MIN(ID), MAX(ID), COUNT(*), nt
FROM
    (SELECT 
        `ID`,
            IF(@countr < @div2, @ntile, @ntile:=@ntile + 1) AS nt,
            IF(@countr < @div2, @countr:=@countr + 1, @countr:=1) c1,
            IF(@ntile <= CAST(@mod AS UNSIGNED), @div2:=@div + 1, @div2:=@div) div2
    FROM
        (SELECT 
        ID, @mod:=countr % 16, @div:=countr DIV 16, @div2:=@div
    FROM
        table1, (SELECT 
        COUNT(*) countr
    FROM
        table1, (SELECT @ntile:=1, @countr:=0, @div2:=0) t3) t2) t1
    ORDER BY ID) t1
GROUP BY nt
ORDER BY CAST(nt AS UNSIGNED);


MIN(ID)
MAX(ID)
COUNT(*)
nt


'0138ba80-47ad-414a-bcea-65f0ca165a2a
022f1261-32e7-4870-bc29-2fc770260bc2
3
1

02d756dc-c6ca-446a-a17a-ab52b1341595
03c56406-91f0-4c25-9d07-a4c91df565e5
3
2

0521cabb-94de-4186-ae8e-07e11b8de01f
0822c7fb-ebe9-43cd-8f0e-df7fda50f711
3
3

09353ab2-6e17-4948-868c-a617977f3902
0a11a144-6e88-106d-9ba2-11060000002a
3
4

0a11a144-6e88-106d-9ba2-11970000002c
0a11a144-6e88-106d-9ba2-4fb40000005f
3
5

0a11a144-6e88-106d-9ba2-4fbd00000060
0a11a144-6e88-106d-9ba2-56cf0000006d
3
6

0a11a144-6e88-106d-9ba2-57b200000073
0a11a144-6e88-106d-9ba2-580d00000078
3
7

0a11a144-6e88-106d-9ba2-581100000079
0a11a144-6e8d-190f-9ba3-64fe00000001
3
8

0a11a144-6e8d-190f-9ba3-683100000010
0a11a144-6e8d-190f-9ba3-68e20000001e
3
9

0a11a144-6e8d-190f-9ba3-691700000020
0a11a144-6e8d-190f-9ba4-b201000001c4
3
10

0a11a144-6e8d-190f-9ba4-b290000001cc
0a348078-58fd-12fd-963f-86fa000008a2
3
11

0a348078-58fd-12fd-9640-24f000000c9d
0a348078-58fd-12fd-9641-ba92000649b0
3
12

0a348078-58fd-12fd-9641-dc9800070215
0a348078-58fd-12fd-9641-e05900070345
2
13

0a348078-58fd-12fd-9641-e0bf00070351
0a348078-58fd-12fd-9642-bcfe00099496
2
14

0a348078-58fd-12fd-9644-06b9000c1f04
0a348078-5911-1bfe-9645-4b370000032a
2
15

0a348078-5916-1f0d-9646-94da00001308
0a348078-5916-1f0d-9649-2cfa00053e55
2
16


select 
min(ID)
, max(ID)
,count(*)
, nt 
from 
( select 
		ID
        , ntile(16) over (order by ID) nt 
	from table1)  t1
group by nt order by nt;


min(ID)
max(ID)
count(*)
nt


'0138ba80-47ad-414a-bcea-65f0ca165a2a
022f1261-32e7-4870-bc29-2fc770260bc2
3
1

02d756dc-c6ca-446a-a17a-ab52b1341595
03c56406-91f0-4c25-9d07-a4c91df565e5
3
2

0521cabb-94de-4186-ae8e-07e11b8de01f
0822c7fb-ebe9-43cd-8f0e-df7fda50f711
3
3

09353ab2-6e17-4948-868c-a617977f3902
0a11a144-6e88-106d-9ba2-11060000002a
3
4

0a11a144-6e88-106d-9ba2-11970000002c
0a11a144-6e88-106d-9ba2-4fb40000005f
3
5

0a11a144-6e88-106d-9ba2-4fbd00000060
0a11a144-6e88-106d-9ba2-56cf0000006d
3
6

0a11a144-6e88-106d-9ba2-57b200000073
0a11a144-6e88-106d-9ba2-580d00000078
3
7

0a11a144-6e88-106d-9ba2-581100000079
0a11a144-6e8d-190f-9ba3-64fe00000001
3
8

0a11a144-6e8d-190f-9ba3-683100000010
0a11a144-6e8d-190f-9ba3-68e20000001e
3
9

0a11a144-6e8d-190f-9ba3-691700000020
0a11a144-6e8d-190f-9ba4-b201000001c4
3
10

0a11a144-6e8d-190f-9ba4-b290000001cc
0a348078-58fd-12fd-963f-86fa000008a2
3
11

0a348078-58fd-12fd-9640-24f000000c9d
0a348078-58fd-12fd-9641-ba92000649b0
3
12

0a348078-58fd-12fd-9641-dc9800070215
0a348078-58fd-12fd-9641-e05900070345
2
13

0a348078-58fd-12fd-9641-e0bf00070351
0a348078-58fd-12fd-9642-bcfe00099496
2
14

0a348078-58fd-12fd-9644-06b9000c1f04
0a348078-5911-1bfe-9645-4b370000032a
2
15

0a348078-5916-1f0d-9646-94da00001308
0a348078-5916-1f0d-9649-2cfa00053e55
2
16

MIN(ID)	MAX(ID)	COUNT(*)	nt
'0138ba80-47ad-414a-bcea-65f0ca165a2a	022f1261-32e7-4870-bc29-2fc770260bc2	3	1
02d756dc-c6ca-446a-a17a-ab52b1341595	03c56406-91f0-4c25-9d07-a4c91df565e5	3	2
0521cabb-94de-4186-ae8e-07e11b8de01f	0822c7fb-ebe9-43cd-8f0e-df7fda50f711	3	3
09353ab2-6e17-4948-868c-a617977f3902	0a11a144-6e88-106d-9ba2-11060000002a	3	4
0a11a144-6e88-106d-9ba2-11970000002c	0a11a144-6e88-106d-9ba2-4fb40000005f	3	5
0a11a144-6e88-106d-9ba2-4fbd00000060	0a11a144-6e88-106d-9ba2-56cf0000006d	3	6
0a11a144-6e88-106d-9ba2-57b200000073	0a11a144-6e88-106d-9ba2-580d00000078	3	7
0a11a144-6e88-106d-9ba2-581100000079	0a11a144-6e8d-190f-9ba3-64fe00000001	3	8
0a11a144-6e8d-190f-9ba3-683100000010	0a11a144-6e8d-190f-9ba3-68e20000001e	3	9
0a11a144-6e8d-190f-9ba3-691700000020	0a11a144-6e8d-190f-9ba4-b201000001c4	3	10
0a11a144-6e8d-190f-9ba4-b290000001cc	0a348078-58fd-12fd-963f-86fa000008a2	3	11
0a348078-58fd-12fd-9640-24f000000c9d	0a348078-58fd-12fd-9641-ba92000649b0	3	12
0a348078-58fd-12fd-9641-dc9800070215	0a348078-58fd-12fd-9641-e05900070345	2	13
0a348078-58fd-12fd-9641-e0bf00070351	0a348078-58fd-12fd-9642-bcfe00099496	2	14
0a348078-58fd-12fd-9644-06b9000c1f04	0a348078-5911-1bfe-9645-4b370000032a	2	15
0a348078-5916-1f0d-9646-94da00001308	0a348078-5916-1f0d-9649-2cfa00053e55	2	16