In some applications, you have to write the starting number in the first row (lets assume that is cell A1), then enter "=A1+1" in cell A2 and then autofill from cell A2 to all the other cells in the column.
I don't have iWork '06, so I cannot check if this works there, too.