Yes, this can be added in Google Sheets…would rather have a native solution. Just a simple 1 through X where X is the number of rows in the table. This would work REALLY well with the Single Value column.
@Robert_Petitto would be very beneficial e.g. when using increment action