delete single order from database using query

SET @orderId = xxxxxxxxx; #replace this WITH your ORDER NUMBER

SET FOREIGN_KEY_CHECKS = 1;

DELETE FROM sales_flat_quote

      WHERE reserved_order_id = @orderId;

DELETE FROM sales_flat_order

      WHERE increment_id = @orderId;