SELECT t.*
FROM transactions t
WHERE t.id = (SELECT MAX(t2.id)
              FROM transactions t2
              WHERE t2.package_customer_id = t.package_customer_id
             );