Automatic resource naming seems inconsistent

Hi,
I've noticed that whenever we create a new resource under same resource type folder, the index in the name does not increment automatically. It would be convinient to increment the index if user relies on automatic naming.
For example: These three sprite resources are created with the same name:

Reproduce the issue by creating multiple sprite resources under the same resource type folder, then trace the automatic naming flow that assigns their names. Done means newly created resources receive distinct names with incrementing indexes instead of repeating the same name.

Written by the indexing model from the issue text.