Apex Court ordered to release Cauvery water from October 1 to 6