A pilot in which homes had food waste collected separately and composted is hailed a success by government advisers.