Split trues/falses then get the id's which exist in both group.

SQL Server;

select distinct t1.ID from (select ID from thetable where VALUE='false' ) t1,
(select ID from thetable where VALUE='true') t2
where t1.ID=t2.ID