SIXTH AMENDED AND RESTATED AGREEMENT OF LIMITED PARTNERSHIP OF ALTA MESA HOLDINGS, LP (A Texas Limited Partnership)