Andy Mangan, a former striker for Wrexham, Shrewsbury and Tranmere, looked set for a dream move to coach with Real Madrid, before Brexit regulations saw him denied a work permit