The Scottish government has been told to bring its sewage "crisis" under control after a record 100,000 spills were recorded in a single year.