Using Automations Or Triggers To Delete Tickets

Due to data and privacy laws we need to ensure our tickets are deleted 6 years after creation. The system currently only allows this by API or manual action.

It would be great if this could be completed via a trigger or automation so this can be maintained and changed easily if we ever need to.