Rewrite Optional Filter Query Without COALESCE Trap

Rewrite for index safety: return paid orders, optional customer_id filter (parameter :customer_id may be null).

orders(order_id, customer_id, status, created_at)