How to use postgres subquery result to filter overall results

I have this simple query

 SELECT c1.id AS id,
       c1.title AS title,
         (
    SELECT  b1.price
    FROM bids b1
    WHERE b1.product = c1.id
    ORDER BY b1.price DESC
    LIMIT 1
  ) AS highest_offer
  
  FROM products c1
ORDER BY highest_offer

and getting results like

however If I want to add this query

WHERE highest_offer = '538.16' 

I gets error :

 error: column "highest_offer" does not exist

Please help me

I tried different things but nothing worked.