Detectives say Robert, who was known as Scott, was at the Coronation Street property on the night he went missing over 20 years ago, in 2002