Make ticket_number an auto_increment column
CREATE TABLE raffle (
name VARCHAR(50)
ticket_number INT NOT NULL auto_increment primary key
);
INSERT INTO raffle (name) VALUES
('Curly'),
('Curly'),
('Curly'),
('Larry'),
('Larry'),
('Larry'),
('Larry'),
('Larry'),
('Mo'),
('Mo'),
('Mo'),
('Mo'),
('Mo'),
('Mo');
SELECT name, ticket_number FROM raffle;
+-------+---------------+
| name | ticket_number |
+-------+---------------+
| Curly | 1 |
| Curly | 2 |
| Curly | 3 |
| Larry | 4 |
| Larry | 5 |
| Larry | 6 |
| Larry | 7 |
| Larry | 8 |
| Mo | 9 |
| Mo | 10 |
| Mo | 11 |
| Mo | 12 |
| Mo | 13 |
| Mo | 14 |
+-------+---------------+