If you first input a serial no. manually in A1, try this in A2 and copy down as far as needed.

A2 =IF(B2="","",A1+1)