for a better performance, you can also use,

Select distinct t1.ID from your_table t1
where VALUE = 'TRUE'
and exists (
select 1 from your_table t2
where t1.ID = t2.ID and t2.VALUE = 'FALSE'
);