How do I create the sql query to collect info about the records with f.i. the following id's: 1,6,10 ?

I now how to collect all of them or just one (id=1 f.i.) or al above six (id>6 f.i.). But how can I collect specific ones ?