Acorn Union issues apology after prospective renter in Manchester was told 'we are a pro-Palestine organization,' says it has launched internal probe