Sequential Name Formula?

Indeed. Sorry

Names are strings, so there’s no easy way to add 1 to a string.
Until we have the ability to convert text to number, a numerical index field is the only way to go