How to fetch rows with multiple values

Hi,

I have a table like this:

CREATE TABLE customer_mapping
(
"Name" varchar(128) NOT NULL,
"ID" int8 NOT NULL
)

Data looks something like this:

"john" 1
"peter" 1
"test" 2
"george" 3

What I would like is to write a query where I can specify multiple names and
get the IDs which have them.

For now it seems the most efficient way is to use INTERSECT statement:

SELECT "ID" from customer_mapping WHERE "Name"='john'
INTERSECT
SELECT "ID" from customer_mapping WHERE "Name"='peter'

Although, I don't know how exactly to use ORDER, OFFSET and LIMIT in this
case...

Anyway, is there any better way of doing this? (I can't change the table
structure.)

Thanks, Sebastjan