Laws weakening freedom of information rights in Scotland look set to be repealed after just a few weeks because opposition MSPs have united against them.