How to alter a view sort order?
Yes finally i am able to solve this one.

Using 

function utility_views_query_alter(&amp;$view, &amp;$query) {

  if ($view-&gt;name == 'Viewname') {

    //dpm($view-&gt;query-&gt;orderby[0]);
 $view-&gt;query-&gt;orderby[0]['field'] = "CASE  field_data_field_bid_test_field_bid_test_value WHEN 'Pass' THEN 1 WHEN 'Fail' THEN 2 WHEN 'Waiting' THEN 3 ELSE 4 END";
  }
}