He came tantalisingly close to breaking up Britain, but he could still be generous to those, like me, who opposed him