Was John Adams the second President of the US?

Yes, John Adams was the 2nd president of the USA.

Later his son, John Quincy Adams, became the 6th president of the USA.