$link = mysqli_connect($host, $user, $password, $database)
            or die("Ошибка " . mysqli_error($link));
$query2 = mysqli_query($link,"SELECT * FROM zakaz1 WHERE Nomer IN(SELECT MAX(Nomer) FROM zakaz1)");
echo "$query2";
mysqli_close($link);