Southampton's council has issued an apology after failings were made in how it handled a resident’s care arrangements when he left hospital