Study finds 86% of drivers agree with council trials using cameras to snap parents stopping on yellow or zigzag lines