Piece comprising a substrate bearing a layer of ceramic coating