WP_Query Excluding pages with Order is 0

You can define custom where like this if your table is wp_posts

function _20170112( $where ){    

  $where = $where . ' AND wp_posts.menu_order > 0 ';             
  return $where;
}

And sandwich your query with this:

$args = array(      
    'post_type' => 'page',
    'post_status' => 'publish',
    'meta_key' => 'tile-home',
    'meta_value' => 1,
    'orderby' => 'menu_order',
    'order' => 'ASC'
);


add_filter( 'posts_where', '_20170112' );
$q = new WP_Query($args);
remove_filter( 'posts_where', '_20170112' );