The terrifying horror movie filmed in Manchester that made government's infamous 'video nasties' list