Auto Serial Number

You can write formula in A1 =ROWS($A$1:$A1) and drag it down.

Once you insert desired number of rows you can drag formula from above to fill empty (new) cells and then double click black cross in the bottom right corner to fill formula all the way down.

Untitled.png

Similarly when you deleting rows.

It's not automatic.. But let's call it semi-automatic