MySQL Error Occurred

Error Message:
3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'a1f9463_cc4.CubeCart_order_inv.id' which is not in SELECT list; this is incompatible with DISTINCT

SQL:
SELECT DISTINCT `cart_order_id` FROM `CubeCart_order_inv` WHERE `productId` = 979 ORDER BY `id` DESC LIMIT 25