MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.36


-- Create table
CREATE TABLE GetTicketNumbers (
    i INT,
    UID NVARCHAR(50),
    TicketNumber INT
);

-- Insert rows
INSERT INTO GetTicketNumbers (i, UID, TicketNumber) VALUES (2, '09901a22c7c3acc6786847c775f1d113', 10);
INSERT INTO GetTicketNumbers (i, UID, TicketNumber) VALUES (6, '00dad28bef21f916240d6e8c1c1bd67d', 5);
INSERT INTO GetTicketNumbers (i, UID, TicketNumber) VALUES (12, '00dad28bef21f916240d6e8c1c1bd67d', 20);


SELECT * FROM GetTicketNumbers


i
UID
TicketNumber


2
09901a22c7c3acc6786847c775f1d113
10

6
00dad28bef21f916240d6e8c1c1bd67d
5

12
00dad28bef21f916240d6e8c1c1bd67d
20


WITH RECURSIVE CTE AS (
        SELECT i, UID, TicketNumber, 1 AS RowNo FROM GetTicketNumbers
        UNION ALL
        SELECT i, UID, TicketNumber, RowNo+1 
        FROM CTE c
        WHERE RowNo < TicketNumber
    )
    SELECT *, ROW_NUMBER() OVER (ORDER BY i,RowNo) as TotalRowNumber
    FROM CTE;




i
UID
TicketNumber
RowNo
TotalRowNumber


2
09901a22c7c3acc6786847c775f1d113
10
1
1

2
09901a22c7c3acc6786847c775f1d113
10
2
2

2
09901a22c7c3acc6786847c775f1d113
10
3
3

2
09901a22c7c3acc6786847c775f1d113
10
4
4

2
09901a22c7c3acc6786847c775f1d113
10
5
5

2
09901a22c7c3acc6786847c775f1d113
10
6
6

2
09901a22c7c3acc6786847c775f1d113
10
7
7

2
09901a22c7c3acc6786847c775f1d113
10
8
8

2
09901a22c7c3acc6786847c775f1d113
10
9
9

2
09901a22c7c3acc6786847c775f1d113
10
10
10

6
00dad28bef21f916240d6e8c1c1bd67d
5
1
11

6
00dad28bef21f916240d6e8c1c1bd67d
5
2
12

6
00dad28bef21f916240d6e8c1c1bd67d
5
3
13

6
00dad28bef21f916240d6e8c1c1bd67d
5
4
14

6
00dad28bef21f916240d6e8c1c1bd67d
5
5
15

12
00dad28bef21f916240d6e8c1c1bd67d
20
1
16

12
00dad28bef21f916240d6e8c1c1bd67d
20
2
17

12
00dad28bef21f916240d6e8c1c1bd67d
20
3
18

12
00dad28bef21f916240d6e8c1c1bd67d
20
4
19

12
00dad28bef21f916240d6e8c1c1bd67d
20
5
20

12
00dad28bef21f916240d6e8c1c1bd67d
20
6
21

12
00dad28bef21f916240d6e8c1c1bd67d
20
7
22

12
00dad28bef21f916240d6e8c1c1bd67d
20
8
23

12
00dad28bef21f916240d6e8c1c1bd67d
20
9
24

12
00dad28bef21f916240d6e8c1c1bd67d
20
10
25

12
00dad28bef21f916240d6e8c1c1bd67d
20
11
26

12
00dad28bef21f916240d6e8c1c1bd67d
20
12
27

12
00dad28bef21f916240d6e8c1c1bd67d
20
13
28

12
00dad28bef21f916240d6e8c1c1bd67d
20
14
29

12
00dad28bef21f916240d6e8c1c1bd67d
20
15
30

12
00dad28bef21f916240d6e8c1c1bd67d
20
16
31

12
00dad28bef21f916240d6e8c1c1bd67d
20
17
32

12
00dad28bef21f916240d6e8c1c1bd67d
20
18
33

12
00dad28bef21f916240d6e8c1c1bd67d
20
19
34

12
00dad28bef21f916240d6e8c1c1bd67d
20
20
35
i	UID	TicketNumber
2	09901a22c7c3acc6786847c775f1d113	10
6	00dad28bef21f916240d6e8c1c1bd67d	5
12	00dad28bef21f916240d6e8c1c1bd67d	20