This is possible, but it involves having a new table for each year. It will still create all the records in the same table, however, using an automation.
Set up as follows:
You need a table for your records, and a table for each year (or period of time after which you want to reset your numbers. In this "Records" table you need a formula for "Current year", e.g. DATETIME_FORMAT(TODAY(), "YYYY")
In each of your year tables, set the primary field as an autonumber field. Then in the 2023 table, have a formula like "2023" & "-" & {Autonumber} Do the same in the 2024 table, with a formula "2024" & "-" {Autonumber} and so on. In each of the year tables, also have a single line text field. This is just so the automation has something to fill in, it's not doing anything else.
Now your automation works like this:
Trigger: When a record is created in the "Records" table, take the following conditional action:
If {Current year} is 2023 > Create a record in the "2023" table where {Single line text field} contains {Airtable Record ID}
then, Update record in the "Records" table so that the {Name} field contains the content of the formula from the 2023 table. This will be your reference number.
You then add on a second conditional action so that If {Current year} is 2024...and repeat.
It might take a video (or a lot of screenshots!) to demo properly but hopefully this makes sense?
