query for twin primes

[Elim Qiu]

I have a prime table
+-----+------+---------+
| oid | pv   | descipt |
+-----+------+---------+
|   1 |    2 | NULL    |
|   2 |    3 | NULL    |
|   3 |    5 | NULL    |
|   4 |    7 | NULL    |
|   5 |   11 | NULL    |
|  .....................    |
+-----+------+---------+

what the query will be if i like to find all rows where pv+2's are
also in colum 'pv', where oid < 1000000?

In other words, how to get the list of yonger brother of the twin
primes within certain bound?

Thanks