why?

Question

during limit statement you written that SQL count starts from 0 so if we write 3 it will be starts from id no. 4 but in this section it is not like that why?

Answer 1

LIMIT will display just that number of records. LIMIT 3 will display 3 records from the top.

Probably you are looking for OFFSET which skips that many records.
LIMIT 1 OFFSET 2 -> this means it will display 1 record after skipping the initial 2 records, so the 3rd record is displayed.