Counties Manukau have caused the biggest shock result of the National Provincial Championship season.