The US Navy has called off the search at sea for sailors missing after a collision between a destroyer and an oil tanker, and confirmed the identity of one body.