The Scottish Government has been forced into a u-turn on its plans to pilot juryless rape trials after failing to find support from opposition MSPs.