Hundreds of police officers lined the street at the funeral of a colleague who was killed in a collision on the A66.