Paul Foy and an accomplice were caught on CCTV arriving at the flat in Dundee before carrying out the brutal attack