SELECT LATEST ENTRY ON GROUP BY
SELECT *
FROM account_logs 
WHERE ID IN (
  SELECT MAX(ID)
  FROM account_logs 
  WHERE customer_id = 1061 
  GROUP BY DATE )
ORDER BY DATE ASC ;


The sub-query should return all the ID's that you are interested in.