A convicted sex offender was caught on CCTV footage escaping from jail by scaling a prison wall "like Spider-man" in a feat which took him just 26 seconds, police said.