FInd what ticket number is max in your deployment.
SELECT config_ticket_prefix, config_ticket_next_number
FROM settings;
To reset all tickets
UPDATE settings
SET config_ticket_next_number = 1;
and to reset a certain prefix.
UPDATE settings
SET config_ticket_prefix = 'TCK-', config_ticket_next_number = 1;